Dataset statistics
| Number of variables | 25 |
|---|---|
| Number of observations | 221209 |
| Missing cells | 1390304 |
| Missing cells (%) | 25.1% |
| Duplicate rows | 0 |
| Duplicate rows (%) | 0.0% |
| Total size in memory | 42.2 MiB |
| Average record size in memory | 200.0 B |
Variable types
| Categorical | 10 |
|---|---|
| Numeric | 15 |
PPG has a high cardinality: 314 distinct values | High cardinality |
Week has a high cardinality: 185 distinct values | High cardinality |
Sub_Brand has a high cardinality: 55 distinct values | High cardinality |
F_Group has a high cardinality: 65 distinct values | High cardinality |
Pack_Size_Num is highly overall correlated with Base_Price_Per_KG and 9 other fields | High correlation |
Category_Value is highly overall correlated with Category_Volume and 2 other fields | High correlation |
Category_Volume is highly overall correlated with Category_Value and 2 other fields | High correlation |
Base_Volume is highly overall correlated with Non_Promo_Volume and 3 other fields | High correlation |
Non_Promo_Volume is highly overall correlated with Base_Volume and 2 other fields | High correlation |
Promo_Volume is highly overall correlated with Promo_Value | High correlation |
Base_Value is highly overall correlated with Base_Volume and 2 other fields | High correlation |
Non_Promo_Value is highly overall correlated with Base_Volume and 2 other fields | High correlation |
Promo_Value is highly overall correlated with Promo_Volume | High correlation |
Base_Price_Per_KG is highly overall correlated with Pack_Size_Num and 6 other fields | High correlation |
Non_Promo_Price_Per_KG is highly overall correlated with Pack_Size_Num and 7 other fields | High correlation |
Promo_Price_Per_KG is highly overall correlated with Pack_Size_Num and 7 other fields | High correlation |
Distribution_wtd is highly overall correlated with Distribution_numeric | High correlation |
Distribution_numeric is highly overall correlated with Distribution_wtd | High correlation |
Retailer_Name is highly overall correlated with Category_Value and 1 other fields | High correlation |
Category is highly overall correlated with Pack_Size_Num and 10 other fields | High correlation |
Brand is highly overall correlated with Pack_Size_Num and 4 other fields | High correlation |
Sub_Brand is highly overall correlated with Pack_Size_Num and 9 other fields | High correlation |
Pack_Type is highly overall correlated with Pack_Size_Num and 6 other fields | High correlation |
Pack_Size is highly overall correlated with Pack_Size_Num and 9 other fields | High correlation |
Modelling_Group is highly overall correlated with Pack_Size_Num and 6 other fields | High correlation |
F_Group is highly overall correlated with Pack_Size_Num and 9 other fields | High correlation |
Category_Value has 45032 (20.4%) missing values | Missing |
Category_Volume has 45032 (20.4%) missing values | Missing |
Base_Volume has 88602 (40.1%) missing values | Missing |
Non_Promo_Volume has 94079 (42.5%) missing values | Missing |
Promo_Volume has 189575 (85.7%) missing values | Missing |
Base_Value has 88602 (40.1%) missing values | Missing |
Non_Promo_Value has 94079 (42.5%) missing values | Missing |
Promo_Value has 189575 (85.7%) missing values | Missing |
Base_Price_Per_KG has 88602 (40.1%) missing values | Missing |
Non_Promo_Price_Per_KG has 94079 (42.5%) missing values | Missing |
Promo_Price_Per_KG has 189575 (85.7%) missing values | Missing |
Distribution_wtd has 91859 (41.5%) missing values | Missing |
Distribution_numeric has 91613 (41.4%) missing values | Missing |
Reproduction
| Analysis started | 2023-04-15 20:59:13.946042 |
|---|---|
| Analysis finished | 2023-04-15 20:59:34.745638 |
| Duration | 20.8 seconds |
| Software version | pandas-profiling v3.6.6 |
| Download configuration | config.json |
PPG
Categorical
| Distinct | 314 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| BRAND F SUBBRAND F.1 ADULT BLIK RND_KP_KN_LV_ZVS_SPN_ND_KLK 680_G_8_ST | 2535 |
|---|---|
| BRAND F SUBBRAND F.1 ADULT BLIK TON_RND_KLK_LV 680_G_8_ST | 2535 |
| BRAND D SUBBRAND D.2 SENIOR POUCH KIP_RND_TN_ZLM 1200_G_12_ST | 2535 |
| BRAND D SUBBRAND D.2 SENIOR POUCH FOR_TN_SR_ZLM 1200_G_12_ST | 2535 |
| BRAND F SUBBRAND F.1 ADULT BLIK KIP_KN_NR_ZLM 680_G_8_ST | 2535 |
| Other values (309) |
Length
| Max length | 74 |
|---|---|
| Median length | 64 |
| Mean length | 52.379352 |
| Min length | 21 |
Characters and Unicode
| Total characters | 11586784 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 5 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BRAND A SUBBRAND A.1 ADULT ZAK GROENTE_KIP_RIJST 1500_G |
|---|---|
| 2nd row | BRAND A SUBBRAND A.1 ADULT ZAK GROENTE_KIP_RIJST 1500_G |
| 3rd row | BRAND A SUBBRAND A.1 ADULT ZAK GROENTE_KIP_RIJST 1500_G |
| 4th row | BRAND A SUBBRAND A.1 ADULT ZAK GROENTE_KIP_RIJST 1500_G |
| 5th row | BRAND A SUBBRAND A.1 ADULT ZAK GROENTE_KIP_RIJST 1500_G |
Common Values
| Value | Count | Frequency (%) |
| BRAND F SUBBRAND F.1 ADULT BLIK RND_KP_KN_LV_ZVS_SPN_ND_KLK 680_G_8_ST | 2535 | 1.1% |
| BRAND F SUBBRAND F.1 ADULT BLIK TON_RND_KLK_LV 680_G_8_ST | 2535 | 1.1% |
| BRAND D SUBBRAND D.2 SENIOR POUCH KIP_RND_TN_ZLM 1200_G_12_ST | 2535 | 1.1% |
| BRAND D SUBBRAND D.2 SENIOR POUCH FOR_TN_SR_ZLM 1200_G_12_ST | 2535 | 1.1% |
| BRAND F SUBBRAND F.1 ADULT BLIK KIP_KN_NR_ZLM 680_G_8_ST | 2535 | 1.1% |
| BRAND D SUBBRAND D.2 KITTEN POUCH KIP_RND_TN_ZLM 1200_G_12_ST | 2535 | 1.1% |
| BRAND D SUBBRAND D.2 ADULT POUCH TON_ZLM_KB_SCHL 1200_G_12_ST | 2535 | 1.1% |
| BRAND D SUBBRAND D.2 ADULT POUCH RND_WRT_KP_TM_ZLM_CR_FR_SPR 1200_G_12_ST | 2535 | 1.1% |
| BRAND D SUBBRAND D.2 ADULT POUCH RND_KP_TN_ZLM 1200_G_12_ST | 2535 | 1.1% |
| BRAND F SUBBRAND F.1 ADULT BLIK RND_TM_KP_WRT_KLK_SPN_LM_SPR 680_G_8_ST | 2535 | 1.1% |
| Other values (304) | 195859 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| brand | 221209 | 12.5% |
| subbrand | 220533 | 12.5% |
| adult | 183979 | 10.4% |
| pouch | 78270 | 4.4% |
| zak | 58822 | 3.3% |
| d | 56393 | 3.2% |
| blik | 56108 | 3.2% |
| 1200_g_12_st | 46644 | 2.6% |
| f | 42081 | 2.4% |
| j | 33870 | 1.9% |
| Other values (269) | 769059 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1546266 | 13.3% | |
| D | 858308 | 7.4% |
| _ | 850364 | 7.3% |
| A | 768310 | 6.6% |
| B | 748368 | 6.5% |
| N | 735751 | 6.3% |
| R | 687995 | 5.9% |
| U | 511157 | 4.4% |
| L | 455252 | 3.9% |
| T | 426923 | 3.7% |
| Other values (27) | 3998090 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 7830667 | |
| Space Separator | 1546266 | 13.3% |
| Decimal Number | 1121431 | 9.7% |
| Connector Punctuation | 850364 | 7.3% |
| Other Punctuation | 238056 | 2.1% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 858308 | |
| A | 768310 | |
| B | 748368 | |
| N | 735751 | 9.4% |
| R | 687995 | 8.8% |
| U | 511157 | 6.5% |
| L | 455252 | 5.8% |
| T | 426923 | 5.5% |
| S | 406094 | 5.2% |
| K | 380650 | 4.9% |
| Other values (14) | 1851859 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 387616 | |
| 1 | 248033 | |
| 2 | 156833 | |
| 4 | 107698 | 9.6% |
| 8 | 64328 | 5.7% |
| 3 | 61152 | 5.5% |
| 5 | 48985 | 4.4% |
| 6 | 34354 | 3.1% |
| 7 | 8835 | 0.8% |
| 9 | 3597 | 0.3% |
Space Separator
| Value | Count | Frequency (%) |
| 1546266 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 850364 |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 238056 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 7830667 | |
| Common | 3756117 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| D | 858308 | |
| A | 768310 | |
| B | 748368 | |
| N | 735751 | 9.4% |
| R | 687995 | 8.8% |
| U | 511157 | 6.5% |
| L | 455252 | 5.8% |
| T | 426923 | 5.5% |
| S | 406094 | 5.2% |
| K | 380650 | 4.9% |
| Other values (14) | 1851859 |
Common
| Value | Count | Frequency (%) |
| 1546266 | ||
| _ | 850364 | |
| 0 | 387616 | 10.3% |
| 1 | 248033 | 6.6% |
| . | 238056 | 6.3% |
| 2 | 156833 | 4.2% |
| 4 | 107698 | 2.9% |
| 8 | 64328 | 1.7% |
| 3 | 61152 | 1.6% |
| 5 | 48985 | 1.3% |
| Other values (3) | 46786 | 1.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 11586784 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1546266 | 13.3% | |
| D | 858308 | 7.4% |
| _ | 850364 | 7.3% |
| A | 768310 | 6.6% |
| B | 748368 | 6.5% |
| N | 735751 | 6.3% |
| R | 687995 | 5.9% |
| U | 511157 | 4.4% |
| L | 455252 | 3.9% |
| T | 426923 | 3.7% |
| Other values (27) | 3998090 |
Week
Categorical
| Distinct | 185 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| wk 20 09 | 1297 |
|---|---|
| wk 20 25 | 1297 |
| wk 20 18 | 1297 |
| wk 20 19 | 1297 |
| wk 20 20 | 1297 |
| Other values (180) |
Length
| Max length | 8 |
|---|---|
| Median length | 8 |
| Mean length | 8 |
| Min length | 8 |
Characters and Unicode
| Total characters | 1769672 |
|---|---|
| Distinct characters | 13 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | wk 18 21 |
|---|---|
| 2nd row | wk 18 21 |
| 3rd row | wk 18 21 |
| 4th row | wk 18 22 |
| 5th row | wk 18 22 |
Common Values
| Value | Count | Frequency (%) |
| wk 20 09 | 1297 | 0.6% |
| wk 20 25 | 1297 | 0.6% |
| wk 20 18 | 1297 | 0.6% |
| wk 20 19 | 1297 | 0.6% |
| wk 20 20 | 1297 | 0.6% |
| wk 20 21 | 1297 | 0.6% |
| wk 20 22 | 1297 | 0.6% |
| wk 20 23 | 1297 | 0.6% |
| wk 20 24 | 1297 | 0.6% |
| wk 20 26 | 1297 | 0.6% |
| Other values (175) | 208239 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| wk | 221209 | |
| 20 | 73391 | 11.1% |
| 19 | 72094 | 10.9% |
| 18 | 52034 | 7.8% |
| 21 | 42795 | 6.4% |
| 22 | 5155 | 0.8% |
| 23 | 5155 | 0.8% |
| 24 | 5155 | 0.8% |
| 15 | 4650 | 0.7% |
| 17 | 4650 | 0.7% |
| Other values (44) | 177339 |
Most occurring characters
| Value | Count | Frequency (%) |
| 442418 | ||
| 1 | 222045 | |
| w | 221209 | |
| k | 221209 | |
| 2 | 180120 | |
| 0 | 124733 | 7.0% |
| 9 | 88417 | 5.0% |
| 8 | 68342 | 3.9% |
| 3 | 64587 | 3.6% |
| 4 | 60528 | 3.4% |
| Other values (3) | 76064 | 4.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 884836 | |
| Space Separator | 442418 | |
| Lowercase Letter | 442418 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 222045 | |
| 2 | 180120 | |
| 0 | 124733 | |
| 9 | 88417 | 10.0% |
| 8 | 68342 | 7.7% |
| 3 | 64587 | 7.3% |
| 4 | 60528 | 6.8% |
| 5 | 34038 | 3.8% |
| 6 | 21068 | 2.4% |
| 7 | 20958 | 2.4% |
Lowercase Letter
| Value | Count | Frequency (%) |
| w | 221209 | |
| k | 221209 |
Space Separator
| Value | Count | Frequency (%) |
| 442418 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1327254 | |
| Latin | 442418 | 25.0% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| 442418 | ||
| 1 | 222045 | |
| 2 | 180120 | |
| 0 | 124733 | 9.4% |
| 9 | 88417 | 6.7% |
| 8 | 68342 | 5.1% |
| 3 | 64587 | 4.9% |
| 4 | 60528 | 4.6% |
| 5 | 34038 | 2.6% |
| 6 | 21068 | 1.6% |
Latin
| Value | Count | Frequency (%) |
| w | 221209 | |
| k | 221209 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1769672 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 442418 | ||
| 1 | 222045 | |
| w | 221209 | |
| k | 221209 | |
| 2 | 180120 | |
| 0 | 124733 | 7.0% |
| 9 | 88417 | 5.0% |
| 8 | 68342 | 3.9% |
| 3 | 64587 | 3.6% |
| 4 | 60528 | 3.4% |
| Other values (3) | 76064 | 4.3% |
Week_Num
Real number (ℝ)
| Distinct | 185 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 89.2514 |
| Minimum | 1 |
|---|---|
| Maximum | 185 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 12 |
| Q1 | 47 |
| median | 89 |
| Q3 | 132 |
| 95-th percentile | 166 |
| Maximum | 185 |
| Range | 184 |
| Interquartile range (IQR) | 85 |
Descriptive statistics
| Standard deviation | 49.427722 |
|---|---|
| Coefficient of variation (CV) | 0.55380332 |
| Kurtosis | -1.1818477 |
| Mean | 89.2514 |
| Median Absolute Deviation (MAD) | 43 |
| Skewness | 0.001122795 |
| Sum | 19743213 |
| Variance | 2443.0997 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 101 | 1297 | 0.6% |
| 117 | 1297 | 0.6% |
| 110 | 1297 | 0.6% |
| 111 | 1297 | 0.6% |
| 112 | 1297 | 0.6% |
| 113 | 1297 | 0.6% |
| 114 | 1297 | 0.6% |
| 115 | 1297 | 0.6% |
| 116 | 1297 | 0.6% |
| 118 | 1297 | 0.6% |
| Other values (175) | 208239 |
| Value | Count | Frequency (%) |
| 1 | 759 | |
| 2 | 759 | |
| 3 | 759 | |
| 4 | 759 | |
| 5 | 759 | |
| 6 | 759 | |
| 7 | 759 | |
| 8 | 759 | |
| 9 | 1264 | |
| 10 | 1264 |
| Value | Count | Frequency (%) |
| 185 | 15 | < 0.1% |
| 184 | 15 | < 0.1% |
| 183 | 15 | < 0.1% |
| 182 | 15 | < 0.1% |
| 181 | 125 | 0.1% |
| 180 | 125 | 0.1% |
| 179 | 125 | 0.1% |
| 178 | 125 | 0.1% |
| 177 | 744 | |
| 176 | 744 |
Retailer_Name
Categorical
| Distinct | 3 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| Retailer B | |
|---|---|
| Retailer A | |
| Retailer C |
Length
| Max length | 10 |
|---|---|
| Median length | 10 |
| Mean length | 10 |
| Min length | 10 |
Characters and Unicode
| Total characters | 2212090 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | Retailer A |
|---|---|
| 2nd row | Retailer B |
| 3rd row | Retailer C |
| 4th row | Retailer A |
| 5th row | Retailer B |
Common Values
| Value | Count | Frequency (%) |
| Retailer B | 80210 | |
| Retailer A | 73511 | |
| Retailer C | 67488 |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| retailer | 221209 | |
| b | 80210 | 18.1% |
| a | 73511 | 16.6% |
| c | 67488 | 15.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| e | 442418 | |
| R | 221209 | |
| t | 221209 | |
| a | 221209 | |
| i | 221209 | |
| l | 221209 | |
| r | 221209 | |
| 221209 | ||
| B | 80210 | 3.6% |
| A | 73511 | 3.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Lowercase Letter | 1548463 | |
| Uppercase Letter | 442418 | 20.0% |
| Space Separator | 221209 | 10.0% |
Most frequent character per category
Lowercase Letter
| Value | Count | Frequency (%) |
| e | 442418 | |
| t | 221209 | |
| a | 221209 | |
| i | 221209 | |
| l | 221209 | |
| r | 221209 |
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 221209 | |
| B | 80210 | 18.1% |
| A | 73511 | 16.6% |
| C | 67488 | 15.3% |
Space Separator
| Value | Count | Frequency (%) |
| 221209 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1990881 | |
| Common | 221209 | 10.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| e | 442418 | |
| R | 221209 | |
| t | 221209 | |
| a | 221209 | |
| i | 221209 | |
| l | 221209 | |
| r | 221209 | |
| B | 80210 | 4.0% |
| A | 73511 | 3.7% |
| C | 67488 | 3.4% |
Common
| Value | Count | Frequency (%) |
| 221209 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2212090 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| e | 442418 | |
| R | 221209 | |
| t | 221209 | |
| a | 221209 | |
| i | 221209 | |
| l | 221209 | |
| r | 221209 | |
| 221209 | ||
| B | 80210 | 3.6% |
| A | 73511 | 3.3% |
Category
Categorical
| Distinct | 5 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| SINGLE SERVE | |
|---|---|
| DRY | |
| MULTI SERVE | |
| WET | 6084 |
| SNACKS | 4732 |
Length
| Max length | 12 |
|---|---|
| Median length | 11 |
| Mean length | 8.3969504 |
| Min length | 3 |
Characters and Unicode
| Total characters | 1857481 |
|---|---|
| Distinct characters | 18 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | DRY |
|---|---|
| 2nd row | DRY |
| 3rd row | DRY |
| 4th row | DRY |
| 5th row | DRY |
Common Values
| Value | Count | Frequency (%) |
| SINGLE SERVE | 104634 | |
| DRY | 76015 | |
| MULTI SERVE | 29744 | 13.4% |
| WET | 6084 | 2.8% |
| SNACKS | 4732 | 2.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| serve | 134378 | |
| single | 104634 | |
| dry | 76015 | |
| multi | 29744 | 8.4% |
| wet | 6084 | 1.7% |
| snacks | 4732 | 1.3% |
Most occurring characters
| Value | Count | Frequency (%) |
| E | 379474 | |
| S | 248476 | |
| R | 210393 | |
| L | 134378 | 7.2% |
| 134378 | 7.2% | |
| V | 134378 | 7.2% |
| I | 134378 | 7.2% |
| N | 109366 | 5.9% |
| G | 104634 | 5.6% |
| Y | 76015 | 4.1% |
| Other values (8) | 191611 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1723103 | |
| Space Separator | 134378 | 7.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| E | 379474 | |
| S | 248476 | |
| R | 210393 | |
| L | 134378 | 7.8% |
| V | 134378 | 7.8% |
| I | 134378 | 7.8% |
| N | 109366 | 6.3% |
| G | 104634 | 6.1% |
| Y | 76015 | 4.4% |
| D | 76015 | 4.4% |
| Other values (7) | 115596 | 6.7% |
Space Separator
| Value | Count | Frequency (%) |
| 134378 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1723103 | |
| Common | 134378 | 7.2% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| E | 379474 | |
| S | 248476 | |
| R | 210393 | |
| L | 134378 | 7.8% |
| V | 134378 | 7.8% |
| I | 134378 | 7.8% |
| N | 109366 | 6.3% |
| G | 104634 | 6.1% |
| Y | 76015 | 4.4% |
| D | 76015 | 4.4% |
| Other values (7) | 115596 | 6.7% |
Common
| Value | Count | Frequency (%) |
| 134378 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1857481 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| E | 379474 | |
| S | 248476 | |
| R | 210393 | |
| L | 134378 | 7.2% |
| 134378 | 7.2% | |
| V | 134378 | 7.2% |
| I | 134378 | 7.2% |
| N | 109366 | 5.9% |
| G | 104634 | 5.6% |
| Y | 76015 | 4.1% |
| Other values (8) | 191611 |
Brand
Categorical
| Distinct | 15 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| BRAND D | |
|---|---|
| BRAND F | |
| BRAND G | |
| BRAND L | |
| BRAND H | |
| Other values (10) |
Length
| Max length | 7 |
|---|---|
| Median length | 7 |
| Mean length | 7 |
| Min length | 7 |
Characters and Unicode
| Total characters | 1548463 |
|---|---|
| Distinct characters | 17 |
| Distinct categories | 2 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BRAND A |
|---|---|
| 2nd row | BRAND A |
| 3rd row | BRAND A |
| 4th row | BRAND A |
| 5th row | BRAND A |
Common Values
| Value | Count | Frequency (%) |
| BRAND D | 56393 | |
| BRAND F | 42081 | |
| BRAND G | 23076 | |
| BRAND L | 15792 | 7.1% |
| BRAND H | 15717 | 7.1% |
| BRAND O | 15717 | 7.1% |
| BRAND J | 15008 | 6.8% |
| BRAND M | 11709 | 5.3% |
| BRAND B | 8112 | 3.7% |
| BRAND I | 7098 | 3.2% |
| Other values (5) | 10506 | 4.7% |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| brand | 221209 | |
| d | 56393 | 12.7% |
| f | 42081 | 9.5% |
| g | 23076 | 5.2% |
| l | 15792 | 3.6% |
| h | 15717 | 3.6% |
| o | 15717 | 3.6% |
| j | 15008 | 3.4% |
| m | 11709 | 2.6% |
| b | 8112 | 1.8% |
| Other values (6) | 17604 | 4.0% |
Most occurring characters
| Value | Count | Frequency (%) |
| D | 277602 | |
| B | 229321 | |
| A | 223744 | |
| N | 222730 | |
| R | 221209 | |
| 221209 | ||
| F | 42081 | 2.7% |
| G | 23076 | 1.5% |
| L | 15792 | 1.0% |
| H | 15717 | 1.0% |
| Other values (7) | 55982 | 3.6% |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1327254 | |
| Space Separator | 221209 | 14.3% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| D | 277602 | |
| B | 229321 | |
| A | 223744 | |
| N | 222730 | |
| R | 221209 | |
| F | 42081 | 3.2% |
| G | 23076 | 1.7% |
| L | 15792 | 1.2% |
| H | 15717 | 1.2% |
| O | 15717 | 1.2% |
| Other values (6) | 40265 | 3.0% |
Space Separator
| Value | Count | Frequency (%) |
| 221209 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1327254 | |
| Common | 221209 | 14.3% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| D | 277602 | |
| B | 229321 | |
| A | 223744 | |
| N | 222730 | |
| R | 221209 | |
| F | 42081 | 3.2% |
| G | 23076 | 1.7% |
| L | 15792 | 1.2% |
| H | 15717 | 1.2% |
| O | 15717 | 1.2% |
| Other values (6) | 40265 | 3.0% |
Common
| Value | Count | Frequency (%) |
| 221209 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1548463 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| D | 277602 | |
| B | 229321 | |
| A | 223744 | |
| N | 222730 | |
| R | 221209 | |
| 221209 | ||
| F | 42081 | 2.7% |
| G | 23076 | 1.5% |
| L | 15792 | 1.0% |
| H | 15717 | 1.0% |
| Other values (7) | 55982 | 3.6% |
Sub_Brand
Categorical
HIGH CARDINALITY HIGH CORRELATION
| Distinct | 55 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| SUBBRAND J.1 | |
|---|---|
| SUBBRAND F.1 | |
| SUBBRAND D.2 | |
| SUBBRAND F.4 | |
| SUBBRAND D.3 | 11154 |
| Other values (50) |
Length
| Max length | 14 |
|---|---|
| Median length | 12 |
| Mean length | 12.158429 |
| Min length | 12 |
Characters and Unicode
| Total characters | 2689554 |
|---|---|
| Distinct characters | 26 |
| Distinct categories | 4 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | SUBBRAND A.1 |
|---|---|
| 2nd row | SUBBRAND A.1 |
| 3rd row | SUBBRAND A.1 |
| 4th row | SUBBRAND A.1 |
| 5th row | SUBBRAND A.1 |
Common Values
| Value | Count | Frequency (%) |
| SUBBRAND J.1 | 32498 | 14.7% |
| SUBBRAND F.1 | 25350 | 11.5% |
| SUBBRAND D.2 | 24336 | 11.0% |
| SUBBRAND F.4 | 12168 | 5.5% |
| SUBBRAND D.3 | 11154 | 5.0% |
| SUBBRAND G.1 | 8352 | 3.8% |
| SUBBRAND O.3 | 8112 | 3.7% |
| SUBBRAND D.4 | 5649 | 2.6% |
| SUBBRAND H.2 | 5070 | 2.3% |
| SUBBRAND H.1 | 5070 | 2.3% |
| Other values (45) | 83450 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| subbrand | 221209 | |
| j.1 | 32498 | 7.3% |
| f.1 | 25350 | 5.7% |
| d.2 | 24336 | 5.5% |
| f.4 | 12168 | 2.8% |
| d.3 | 11154 | 2.5% |
| g.1 | 8352 | 1.9% |
| o.3 | 8112 | 1.8% |
| d.4 | 5649 | 1.3% |
| h.2 | 5070 | 1.1% |
| Other values (46) | 88520 |
Most occurring characters
| Value | Count | Frequency (%) |
| B | 450530 | |
| D | 283758 | |
| . | 238732 | |
| A | 223744 | |
| N | 222730 | |
| S | 221209 | |
| R | 221209 | |
| 221209 | ||
| U | 221209 | |
| 1 | 101371 | 3.8% |
| Other values (16) | 283853 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 1990881 | |
| Other Punctuation | 238732 | 8.9% |
| Decimal Number | 238732 | 8.9% |
| Space Separator | 221209 | 8.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| B | 450530 | |
| D | 283758 | |
| A | 223744 | |
| N | 222730 | |
| S | 221209 | |
| R | 221209 | |
| U | 221209 | |
| F | 42081 | 2.1% |
| J | 33870 | 1.7% |
| G | 24018 | 1.2% |
| Other values (5) | 46523 | 2.3% |
Decimal Number
| Value | Count | Frequency (%) |
| 1 | 101371 | |
| 2 | 42607 | |
| 3 | 35151 | 14.7% |
| 4 | 31191 | 13.1% |
| 5 | 10284 | 4.3% |
| 6 | 9680 | 4.1% |
| 7 | 5793 | 2.4% |
| 8 | 1593 | 0.7% |
| 9 | 1062 | 0.4% |
Other Punctuation
| Value | Count | Frequency (%) |
| . | 238732 |
Space Separator
| Value | Count | Frequency (%) |
| 221209 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 1990881 | |
| Common | 698673 | 26.0% |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| B | 450530 | |
| D | 283758 | |
| A | 223744 | |
| N | 222730 | |
| S | 221209 | |
| R | 221209 | |
| U | 221209 | |
| F | 42081 | 2.1% |
| J | 33870 | 1.7% |
| G | 24018 | 1.2% |
| Other values (5) | 46523 | 2.3% |
Common
| Value | Count | Frequency (%) |
| . | 238732 | |
| 221209 | ||
| 1 | 101371 | |
| 2 | 42607 | 6.1% |
| 3 | 35151 | 5.0% |
| 4 | 31191 | 4.5% |
| 5 | 10284 | 1.5% |
| 6 | 9680 | 1.4% |
| 7 | 5793 | 0.8% |
| 8 | 1593 | 0.2% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 2689554 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| B | 450530 | |
| D | 283758 | |
| . | 238732 | |
| A | 223744 | |
| N | 222730 | |
| S | 221209 | |
| R | 221209 | |
| 221209 | ||
| U | 221209 | |
| 1 | 101371 | 3.8% |
| Other values (16) | 283853 |
Pack_Type
Categorical
| Distinct | 6 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| POUCH | |
|---|---|
| ZAK | |
| BLIK | |
| PAK | |
| ALU | 5577 |
Length
| Max length | 5 |
|---|---|
| Median length | 4 |
| Mean length | 3.9658829 |
| Min length | 3 |
Characters and Unicode
| Total characters | 877289 |
|---|---|
| Distinct characters | 11 |
| Distinct categories | 1 ? |
| Distinct scripts | 1 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | ZAK |
|---|---|
| 2nd row | ZAK |
| 3rd row | ZAK |
| 4th row | ZAK |
| 5th row | ZAK |
Common Values
| Value | Count | Frequency (%) |
| POUCH | 78777 | |
| ZAK | 58822 | |
| BLIK | 56108 | |
| PAK | 19390 | 8.8% |
| ALU | 5577 | 2.5% |
| BAK | 2535 | 1.1% |
Length
Histogram of lengths of the category
Common Values (Plot)
| Value | Count | Frequency (%) |
| pouch | 78777 | |
| zak | 58822 | |
| blik | 56108 | |
| pak | 19390 | 8.8% |
| alu | 5577 | 2.5% |
| bak | 2535 | 1.1% |
Most occurring characters
| Value | Count | Frequency (%) |
| K | 136855 | |
| P | 98167 | |
| A | 86324 | |
| U | 84354 | |
| O | 78777 | |
| C | 78777 | |
| H | 78777 | |
| L | 61685 | |
| Z | 58822 | |
| B | 58643 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 877289 |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| K | 136855 | |
| P | 98167 | |
| A | 86324 | |
| U | 84354 | |
| O | 78777 | |
| C | 78777 | |
| H | 78777 | |
| L | 61685 | |
| Z | 58822 | |
| B | 58643 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 877289 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| K | 136855 | |
| P | 98167 | |
| A | 86324 | |
| U | 84354 | |
| O | 78777 | |
| C | 78777 | |
| H | 78777 | |
| L | 61685 | |
| Z | 58822 | |
| B | 58643 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 877289 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| K | 136855 | |
| P | 98167 | |
| A | 86324 | |
| U | 84354 | |
| O | 78777 | |
| C | 78777 | |
| H | 78777 | |
| L | 61685 | |
| Z | 58822 | |
| B | 58643 |
Pack_Size
Categorical
| Distinct | 24 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| 1200_G_12_ST | |
|---|---|
| 1000_G | |
| 400_G | |
| 340_G_4_ST | |
| 800_G | |
| Other values (19) |
Length
| Max length | 12 |
|---|---|
| Median length | 6 |
| Mean length | 7.6516552 |
| Min length | 4 |
Characters and Unicode
| Total characters | 1692615 |
|---|---|
| Distinct characters | 14 |
| Distinct categories | 3 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | 1500_G |
|---|---|
| 2nd row | 1500_G |
| 3rd row | 1500_G |
| 4th row | 1500_G |
| 5th row | 1500_G |
Common Values
| Value | Count | Frequency (%) |
| 1200_G_12_ST | 47151 | |
| 1000_G | 24379 | |
| 400_G | 22477 | |
| 340_G_4_ST | 17889 | 8.1% |
| 800_G | 17612 | 8.0% |
| 85_G | 16731 | 7.6% |
| 680_G_8_ST | 10647 | 4.8% |
| 1500_G | 10140 | 4.6% |
| 2000_G | 9688 | 4.4% |
| 405_G | 5070 | 2.3% |
| Other values (14) | 39425 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| 1200_g_12_st | 47151 | |
| 1000_g | 24379 | |
| 400_g | 22477 | |
| 340_g_4_st | 17889 | 8.1% |
| 800_g | 17612 | 8.0% |
| 85_g | 16731 | 7.6% |
| 680_g_8_st | 10647 | 4.8% |
| 1500_g | 10140 | 4.6% |
| 2000_g | 9688 | 4.4% |
| 405_g | 5070 | 2.3% |
| Other values (14) | 39425 |
Most occurring characters
| Value | Count | Frequency (%) |
| _ | 403099 | |
| 0 | 388630 | |
| G | 221209 | |
| 1 | 148352 | 8.8% |
| 2 | 115240 | 6.8% |
| S | 90945 | 5.4% |
| T | 90945 | 5.4% |
| 4 | 76000 | 4.5% |
| 8 | 62735 | 3.7% |
| 5 | 39208 | 2.3% |
| Other values (4) | 56252 | 3.3% |
Most occurring categories
| Value | Count | Frequency (%) |
| Decimal Number | 886417 | |
| Connector Punctuation | 403099 | |
| Uppercase Letter | 403099 |
Most frequent character per category
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 388630 | |
| 1 | 148352 | 16.7% |
| 2 | 115240 | 13.0% |
| 4 | 76000 | 8.6% |
| 8 | 62735 | 7.1% |
| 5 | 39208 | 4.4% |
| 3 | 26001 | 2.9% |
| 6 | 24674 | 2.8% |
| 7 | 3042 | 0.3% |
| 9 | 2535 | 0.3% |
Uppercase Letter
| Value | Count | Frequency (%) |
| G | 221209 | |
| S | 90945 | |
| T | 90945 |
Connector Punctuation
| Value | Count | Frequency (%) |
| _ | 403099 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Common | 1289516 | |
| Latin | 403099 | 23.8% |
Most frequent character per script
Common
| Value | Count | Frequency (%) |
| _ | 403099 | |
| 0 | 388630 | |
| 1 | 148352 | 11.5% |
| 2 | 115240 | 8.9% |
| 4 | 76000 | 5.9% |
| 8 | 62735 | 4.9% |
| 5 | 39208 | 3.0% |
| 3 | 26001 | 2.0% |
| 6 | 24674 | 1.9% |
| 7 | 3042 | 0.2% |
Latin
| Value | Count | Frequency (%) |
| G | 221209 | |
| S | 90945 | |
| T | 90945 |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 1692615 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| _ | 403099 | |
| 0 | 388630 | |
| G | 221209 | |
| 1 | 148352 | 8.8% |
| 2 | 115240 | 6.8% |
| S | 90945 | 5.4% |
| T | 90945 | 5.4% |
| 4 | 76000 | 4.5% |
| 8 | 62735 | 3.7% |
| 5 | 39208 | 2.3% |
| Other values (4) | 56252 | 3.3% |
Pack_Size_Num
Real number (ℝ)
| Distinct | 23 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 851.31138 |
| Minimum | 45 |
|---|---|
| Maximum | 3000 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 45 |
|---|---|
| 5-th percentile | 85 |
| Q1 | 400 |
| median | 800 |
| Q3 | 1200 |
| 95-th percentile | 2000 |
| Maximum | 3000 |
| Range | 2955 |
| Interquartile range (IQR) | 800 |
Descriptive statistics
| Standard deviation | 583.50161 |
|---|---|
| Coefficient of variation (CV) | 0.68541502 |
| Kurtosis | 2.05664 |
| Mean | 851.31138 |
| Median Absolute Deviation (MAD) | 400 |
| Skewness | 1.0619604 |
| Sum | 1.8831774 × 108 |
| Variance | 340474.13 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=23)
| Value | Count | Frequency (%) |
| 1200 | 47151 | |
| 1000 | 24379 | |
| 400 | 23491 | |
| 340 | 17889 | 8.1% |
| 800 | 17612 | 8.0% |
| 85 | 16731 | 7.6% |
| 680 | 10647 | 4.8% |
| 1500 | 10140 | 4.6% |
| 2000 | 9688 | 4.4% |
| 405 | 5070 | 2.3% |
| Other values (13) | 38411 |
| Value | Count | Frequency (%) |
| 45 | 338 | 0.2% |
| 60 | 4394 | 2.0% |
| 80 | 3042 | 1.4% |
| 85 | 16731 | |
| 160 | 4056 | 1.8% |
| 288 | 2028 | 0.9% |
| 300 | 3549 | 1.6% |
| 340 | 17889 | |
| 400 | 23491 | |
| 405 | 5070 | 2.3% |
| Value | Count | Frequency (%) |
| 3000 | 4563 | 2.1% |
| 2000 | 9688 | 4.4% |
| 1500 | 10140 | 4.6% |
| 1400 | 4056 | 1.8% |
| 1200 | 47151 | |
| 1020 | 4611 | 2.1% |
| 1000 | 24379 | |
| 950 | 2535 | 1.1% |
| 800 | 17612 | 8.0% |
| 750 | 3042 | 1.4% |
Category_Value
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 1014 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 45032 |
| Missing (%) | 20.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 297526.93 |
| Minimum | 32474.9 |
|---|---|
| Maximum | 1053967.6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 32474.9 |
|---|---|
| 5-th percentile | 46135.8 |
| Q1 | 103588.4 |
| median | 289281.6 |
| Q3 | 397158.6 |
| 95-th percentile | 643952.3 |
| Maximum | 1053967.6 |
| Range | 1021492.7 |
| Interquartile range (IQR) | 293570.2 |
Descriptive statistics
| Standard deviation | 199481.94 |
|---|---|
| Coefficient of variation (CV) | 0.67046685 |
| Kurtosis | -0.35332846 |
| Mean | 297526.93 |
| Median Absolute Deviation (MAD) | 173884.9 |
| Skewness | 0.57811987 |
| Sum | 5.2417401 × 1010 |
| Variance | 3.9793045 × 1010 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 107673 | 208 | 0.1% |
| 109460.7 | 208 | 0.1% |
| 133399.6 | 208 | 0.1% |
| 110532.1 | 208 | 0.1% |
| 93238.5 | 208 | 0.1% |
| 139455.2 | 208 | 0.1% |
| 95988.3 | 208 | 0.1% |
| 132658.9 | 208 | 0.1% |
| 159722 | 208 | 0.1% |
| 172181.7 | 208 | 0.1% |
| Other values (1004) | 174097 | |
| (Missing) | 45032 | 20.4% |
| Value | Count | Frequency (%) |
| 32474.9 | 179 | |
| 34300.5 | 179 | |
| 36040.2 | 179 | |
| 36369.4 | 179 | |
| 36799.9 | 179 | |
| 36916.6 | 179 | |
| 37438.2 | 179 | |
| 37583.7 | 179 | |
| 37674.6 | 179 | |
| 38320.7 | 70 | < 0.1% |
| Value | Count | Frequency (%) |
| 1053967.6 | 206 | |
| 1011364.6 | 206 | |
| 992106.9 | 206 | |
| 847344.4 | 206 | |
| 829926 | 206 | |
| 829807.3 | 206 | |
| 809121.9 | 206 | |
| 795827.4 | 206 | |
| 773312.9 | 206 | |
| 768076.4 | 137 |
Category_Volume
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 1014 |
|---|---|
| Distinct (%) | 0.6% |
| Missing | 45032 |
| Missing (%) | 20.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 73972.473 |
| Minimum | 10367.7 |
|---|---|
| Maximum | 367289.9 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 10367.7 |
|---|---|
| 5-th percentile | 15017 |
| Q1 | 27358.9 |
| median | 79848.7 |
| Q3 | 95051.1 |
| 95-th percentile | 145159.5 |
| Maximum | 367289.9 |
| Range | 356922.2 |
| Interquartile range (IQR) | 67692.2 |
Descriptive statistics
| Standard deviation | 46501.972 |
|---|---|
| Coefficient of variation (CV) | 0.62863888 |
| Kurtosis | 3.1532192 |
| Mean | 73972.473 |
| Median Absolute Deviation (MAD) | 38145.7 |
| Skewness | 1.0226535 |
| Sum | 1.3032248 × 1010 |
| Variance | 2.1624334 × 109 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 24160.8 | 208 | 0.1% |
| 31677.4 | 208 | 0.1% |
| 42349.9 | 208 | 0.1% |
| 24550.9 | 208 | 0.1% |
| 20878.5 | 208 | 0.1% |
| 32918.2 | 208 | 0.1% |
| 25580.5 | 208 | 0.1% |
| 30372.9 | 208 | 0.1% |
| 64279.4 | 208 | 0.1% |
| 60452.6 | 208 | 0.1% |
| Other values (1004) | 174097 | |
| (Missing) | 45032 | 20.4% |
| Value | Count | Frequency (%) |
| 10367.7 | 179 | |
| 11024.3 | 179 | |
| 11358.7 | 179 | |
| 11412 | 179 | |
| 11531.6 | 179 | |
| 11550.2 | 179 | |
| 11683.5 | 179 | |
| 11930.6 | 179 | |
| 11986.2 | 179 | |
| 12013.8 | 179 |
| Value | Count | Frequency (%) |
| 367289.9 | 206 | |
| 307656.2 | 206 | |
| 303916.6 | 206 | |
| 268988.8 | 206 | |
| 261246.4 | 137 | |
| 245153.7 | 206 | |
| 238404.4 | 137 | |
| 236461.8 | 206 | |
| 223058.5 | 137 | |
| 220722.3 | 206 |
Modelling_Group
Categorical
| Distinct | 25 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| BRAND D WET POUCH ORIGINAL 4(12X100G) | |
|---|---|
| BRAND D WET CAT MUSE PREMIUM 12X400G | |
| BRAND F WET CAN GOLD 6(8X85G) | 13689 |
| BRAND D WET POUCH EDF 4(12X100G) | 13689 |
| BRAND D DRY REGULAR 5X1KG | 12874 |
| Other values (20) |
Length
| Max length | 39 |
|---|---|
| Median length | 33 |
| Mean length | 30.889652 |
| Min length | 15 |
Characters and Unicode
| Total characters | 6833069 |
|---|---|
| Distinct characters | 34 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BRAND B DRY NUGGETS REGULAR 3X3KG |
|---|---|
| 2nd row | BRAND B DRY NUGGETS REGULAR 3X3KG |
| 3rd row | BRAND B DRY NUGGETS REGULAR 3X3KG |
| 4th row | BRAND B DRY NUGGETS REGULAR 3X3KG |
| 5th row | BRAND B DRY NUGGETS REGULAR 3X3KG |
Common Values
| Value | Count | Frequency (%) |
| BRAND D WET POUCH ORIGINAL 4(12X100G) | 18252 | 8.3% |
| BRAND D WET CAT MUSE PREMIUM 12X400G | 16562 | 7.5% |
| BRAND F WET CAN GOLD 6(8X85G) | 13689 | 6.2% |
| BRAND D WET POUCH EDF 4(12X100G) | 13689 | 6.2% |
| BRAND D DRY REGULAR 5X1KG | 12874 | 5.8% |
| BRAND G DRY CAT SPECIALS 4X800G | 11293 | 5.1% |
| BRAND F WET CAN GOLD 4(12X85G) | 11202 | 5.1% |
| BRAND F WET POUCH PERLE 12(4X85G) | 10212 | 4.6% |
| BRAND G DRY CAT REGULAR 4X800G | 9748 | 4.4% |
| BRAND D DRY SPECIALS 5X1KG | 9136 | 4.1% |
| Other values (15) | 94552 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| brand | 221209 | |
| wet | 140462 | 10.6% |
| d | 78287 | 5.9% |
| dry | 76015 | 5.8% |
| pouch | 62505 | 4.7% |
| f | 61974 | 4.7% |
| cat | 57390 | 4.3% |
| regular | 55934 | 4.2% |
| can | 55311 | 4.2% |
| g | 40828 | 3.1% |
| Other values (36) | 469463 |
Most occurring characters
| Value | Count | Frequency (%) |
| 1098169 | ||
| R | 466117 | 6.8% |
| A | 455222 | 6.7% |
| D | 423217 | 6.2% |
| G | 396773 | 5.8% |
| N | 337765 | 4.9% |
| E | 320223 | 4.7% |
| B | 253150 | 3.7% |
| T | 229962 | 3.4% |
| C | 225712 | 3.3% |
| Other values (24) | 2626759 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 4625168 | |
| Space Separator | 1098169 | 16.1% |
| Decimal Number | 904916 | 13.2% |
| Close Punctuation | 93480 | 1.4% |
| Open Punctuation | 93480 | 1.4% |
| Other Punctuation | 17856 | 0.3% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 466117 | 10.1% |
| A | 455222 | 9.8% |
| D | 423217 | 9.2% |
| G | 396773 | 8.6% |
| N | 337765 | 7.3% |
| E | 320223 | 6.9% |
| B | 253150 | 5.5% |
| T | 229962 | 5.0% |
| C | 225712 | 4.9% |
| X | 213030 | 4.6% |
| Other values (12) | 1303997 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 195027 | |
| 1 | 177860 | |
| 4 | 153898 | |
| 5 | 107996 | |
| 2 | 107507 | |
| 8 | 102860 | |
| 3 | 31714 | 3.5% |
| 6 | 28054 | 3.1% |
Space Separator
| Value | Count | Frequency (%) |
| 1098169 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 93480 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 93480 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 17856 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4625168 | |
| Common | 2207901 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 466117 | 10.1% |
| A | 455222 | 9.8% |
| D | 423217 | 9.2% |
| G | 396773 | 8.6% |
| N | 337765 | 7.3% |
| E | 320223 | 6.9% |
| B | 253150 | 5.5% |
| T | 229962 | 5.0% |
| C | 225712 | 4.9% |
| X | 213030 | 4.6% |
| Other values (12) | 1303997 |
Common
| Value | Count | Frequency (%) |
| 1098169 | ||
| 0 | 195027 | 8.8% |
| 1 | 177860 | 8.1% |
| 4 | 153898 | 7.0% |
| 5 | 107996 | 4.9% |
| 2 | 107507 | 4.9% |
| 8 | 102860 | 4.7% |
| ) | 93480 | 4.2% |
| ( | 93480 | 4.2% |
| 3 | 31714 | 1.4% |
| Other values (2) | 45910 | 2.1% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 6833069 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 1098169 | ||
| R | 466117 | 6.8% |
| A | 455222 | 6.7% |
| D | 423217 | 6.2% |
| G | 396773 | 5.8% |
| N | 337765 | 4.9% |
| E | 320223 | 4.7% |
| B | 253150 | 3.7% |
| T | 229962 | 3.4% |
| C | 225712 | 3.3% |
| Other values (24) | 2626759 |
F_Group
Categorical
HIGH CARDINALITY HIGH CORRELATION
| Distinct | 65 |
|---|---|
| Distinct (%) | < 0.1% |
| Missing | 0 |
| Missing (%) | 0.0% |
| Memory size | 1.7 MiB |
| BRAND D WET POUCH EDF 4(12X100G) | |
|---|---|
| BRAND F WET CAN GOLD 24X85G | 13689 |
| BRAND F WET POUCH PERLE 12(4X85G) | 12168 |
| BRAND D DRY REGULAR 5X1KG | 11151 |
| BRAND F WET CAN GOLD 6(8X85G) | 10140 |
| Other values (60) |
Length
| Max length | 39 |
|---|---|
| Median length | 31 |
| Mean length | 26.808426 |
| Min length | 11 |
Characters and Unicode
| Total characters | 5930265 |
|---|---|
| Distinct characters | 37 |
| Distinct categories | 6 ? |
| Distinct scripts | 2 ? |
| Distinct blocks | 1 ? |
The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.
Unique
| Unique | 0 ? |
|---|---|
| Unique (%) | 0.0% |
Sample
| 1st row | BRAND A DRY 1,5KG |
|---|---|
| 2nd row | BRAND A DRY 1,5KG |
| 3rd row | BRAND A DRY 1,5KG |
| 4th row | BRAND A DRY 1,5KG |
| 5th row | BRAND A DRY 1,5KG |
Common Values
| Value | Count | Frequency (%) |
| BRAND D WET POUCH EDF 4(12X100G) | 22815 | 10.3% |
| BRAND F WET CAN GOLD 24X85G | 13689 | 6.2% |
| BRAND F WET POUCH PERLE 12(4X85G) | 12168 | 5.5% |
| BRAND D DRY REGULAR 5X1KG | 11151 | 5.0% |
| BRAND F WET CAN GOLD 6(8X85G) | 10140 | 4.6% |
| BRAND G DRY CAT SPECIALS 4X800G | 9558 | 4.3% |
| BRAND K DRY REGULAR 2KG | 8823 | 4.0% |
| BRAND D WET POUCH ORIGINAL 4(12X100G) | 8112 | 3.7% |
| BRAND H CAN 400G | 8112 | 3.7% |
| BRAND K CAN 400G | 7436 | 3.4% |
| Other values (55) | 109205 |
Length
Histogram of lengths of the category
| Value | Count | Frequency (%) |
| brand | 221209 | |
| wet | 88869 | 7.5% |
| dry | 76015 | 6.4% |
| pouch | 66561 | 5.6% |
| d | 56393 | 4.8% |
| can | 51545 | 4.4% |
| regular | 44967 | 3.8% |
| f | 42081 | 3.6% |
| 4(12x100g | 31941 | 2.7% |
| specials | 28995 | 2.4% |
| Other values (74) | 475364 |
Most occurring characters
| Value | Count | Frequency (%) |
| 962731 | ||
| R | 424764 | 7.2% |
| D | 411415 | 6.9% |
| A | 403254 | 6.8% |
| G | 328291 | 5.5% |
| N | 299842 | 5.1% |
| E | 247636 | 4.2% |
| B | 229321 | 3.9% |
| 0 | 211660 | 3.6% |
| C | 194682 | 3.3% |
| Other values (27) | 2216669 |
Most occurring categories
| Value | Count | Frequency (%) |
| Uppercase Letter | 4011721 | |
| Space Separator | 962731 | 16.2% |
| Decimal Number | 812551 | 13.7% |
| Open Punctuation | 64533 | 1.1% |
| Close Punctuation | 64533 | 1.1% |
| Other Punctuation | 14196 | 0.2% |
Most frequent character per category
Uppercase Letter
| Value | Count | Frequency (%) |
| R | 424764 | 10.6% |
| D | 411415 | 10.3% |
| A | 403254 | 10.1% |
| G | 328291 | 8.2% |
| N | 299842 | 7.5% |
| E | 247636 | 6.2% |
| B | 229321 | 5.7% |
| C | 194682 | 4.9% |
| X | 158778 | 4.0% |
| U | 148289 | 3.7% |
| Other values (13) | 1165449 |
Decimal Number
| Value | Count | Frequency (%) |
| 0 | 211660 | |
| 1 | 160447 | |
| 4 | 128701 | |
| 2 | 98098 | |
| 5 | 89033 | |
| 8 | 86249 | |
| 6 | 20111 | 2.5% |
| 3 | 12675 | 1.6% |
| 7 | 3042 | 0.4% |
| 9 | 2535 | 0.3% |
Space Separator
| Value | Count | Frequency (%) |
| 962731 |
Open Punctuation
| Value | Count | Frequency (%) |
| ( | 64533 |
Close Punctuation
| Value | Count | Frequency (%) |
| ) | 64533 |
Other Punctuation
| Value | Count | Frequency (%) |
| , | 14196 |
Most occurring scripts
| Value | Count | Frequency (%) |
| Latin | 4011721 | |
| Common | 1918544 |
Most frequent character per script
Latin
| Value | Count | Frequency (%) |
| R | 424764 | 10.6% |
| D | 411415 | 10.3% |
| A | 403254 | 10.1% |
| G | 328291 | 8.2% |
| N | 299842 | 7.5% |
| E | 247636 | 6.2% |
| B | 229321 | 5.7% |
| C | 194682 | 4.9% |
| X | 158778 | 4.0% |
| U | 148289 | 3.7% |
| Other values (13) | 1165449 |
Common
| Value | Count | Frequency (%) |
| 962731 | ||
| 0 | 211660 | 11.0% |
| 1 | 160447 | 8.4% |
| 4 | 128701 | 6.7% |
| 2 | 98098 | 5.1% |
| 5 | 89033 | 4.6% |
| 8 | 86249 | 4.5% |
| ( | 64533 | 3.4% |
| ) | 64533 | 3.4% |
| 6 | 20111 | 1.0% |
| Other values (4) | 32448 | 1.7% |
Most occurring blocks
| Value | Count | Frequency (%) |
| ASCII | 5930265 |
Most frequent character per block
ASCII
| Value | Count | Frequency (%) |
| 962731 | ||
| R | 424764 | 7.2% |
| D | 411415 | 6.9% |
| A | 403254 | 6.8% |
| G | 328291 | 5.5% |
| N | 299842 | 5.1% |
| E | 247636 | 4.2% |
| B | 229321 | 3.9% |
| 0 | 211660 | 3.6% |
| C | 194682 | 3.3% |
| Other values (27) | 2216669 |
Base_Volume
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 25829 |
|---|---|
| Distinct (%) | 19.5% |
| Missing | 88602 |
| Missing (%) | 40.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1028.9056 |
| Minimum | 0.1 |
|---|---|
| Maximum | 23900.2 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 0.1 |
|---|---|
| 5-th percentile | 17 |
| Q1 | 199.4 |
| median | 522.9 |
| Q3 | 1233.7 |
| 95-th percentile | 3571.98 |
| Maximum | 23900.2 |
| Range | 23900.1 |
| Interquartile range (IQR) | 1034.3 |
Descriptive statistics
| Standard deviation | 1606.635 |
|---|---|
| Coefficient of variation (CV) | 1.5614988 |
| Kurtosis | 35.754892 |
| Mean | 1028.9056 |
| Median Absolute Deviation (MAD) | 398.2 |
| Skewness | 4.8651229 |
| Sum | 1.3644009 × 108 |
| Variance | 2581275.9 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.2 | 615 | 0.3% |
| 1 | 370 | 0.2% |
| 0.4 | 348 | 0.2% |
| 2.4 | 311 | 0.1% |
| 2 | 294 | 0.1% |
| 0.3 | 275 | 0.1% |
| 0.1 | 253 | 0.1% |
| 0.8 | 191 | 0.1% |
| 4.8 | 176 | 0.1% |
| 3.6 | 164 | 0.1% |
| Other values (25819) | 129610 | |
| (Missing) | 88602 |
| Value | Count | Frequency (%) |
| 0.1 | 253 | |
| 0.2 | 120 | 0.1% |
| 0.3 | 275 | |
| 0.4 | 348 | |
| 0.5 | 33 | < 0.1% |
| 0.6 | 42 | < 0.1% |
| 0.7 | 147 | 0.1% |
| 0.8 | 191 | |
| 0.9 | 50 | < 0.1% |
| 1 | 370 |
| Value | Count | Frequency (%) |
| 23900.2 | 3 | |
| 21573.8 | 3 | |
| 21312.2 | 3 | |
| 20586.6 | 3 | |
| 20447.6 | 3 | |
| 20283 | 3 | |
| 20057.6 | 3 | |
| 19926.2 | 3 | |
| 19723.6 | 3 | |
| 19556.6 | 3 |
Non_Promo_Volume
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 21843 |
|---|---|
| Distinct (%) | 17.2% |
| Missing | 94079 |
| Missing (%) | 42.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 1052.7707 |
| Minimum | 0.1 |
|---|---|
| Maximum | 21516.6 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 0.1 |
|---|---|
| 5-th percentile | 12.1 |
| Q1 | 190.8 |
| median | 538.5 |
| Q3 | 1291.3 |
| 95-th percentile | 3684.855 |
| Maximum | 21516.6 |
| Range | 21516.5 |
| Interquartile range (IQR) | 1100.5 |
Descriptive statistics
| Standard deviation | 1595.9048 |
|---|---|
| Coefficient of variation (CV) | 1.5159092 |
| Kurtosis | 30.075481 |
| Mean | 1052.7707 |
| Median Absolute Deviation (MAD) | 425.9 |
| Skewness | 4.4470029 |
| Sum | 1.3383874 × 108 |
| Variance | 2546912.1 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 1.2 | 641 | 0.3% |
| 1 | 384 | 0.2% |
| 2 | 366 | 0.2% |
| 2.4 | 352 | 0.2% |
| 0.4 | 334 | 0.2% |
| 0.3 | 255 | 0.1% |
| 0.1 | 236 | 0.1% |
| 4.8 | 214 | 0.1% |
| 0.8 | 211 | 0.1% |
| 3.6 | 197 | 0.1% |
| Other values (21833) | 123940 | |
| (Missing) | 94079 |
| Value | Count | Frequency (%) |
| 0.1 | 236 | |
| 0.2 | 105 | < 0.1% |
| 0.3 | 255 | |
| 0.4 | 334 | |
| 0.5 | 25 | < 0.1% |
| 0.6 | 20 | < 0.1% |
| 0.7 | 141 | 0.1% |
| 0.8 | 211 | |
| 0.9 | 39 | < 0.1% |
| 1 | 384 |
| Value | Count | Frequency (%) |
| 21516.6 | 3 | |
| 20788.6 | 3 | |
| 20712 | 3 | |
| 20492 | 3 | |
| 19648 | 3 | |
| 19038.6 | 3 | |
| 18881.6 | 3 | |
| 18873.8 | 3 | |
| 18820.4 | 3 | |
| 18276.4 | 3 |
Promo_Volume
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 7573 |
|---|---|
| Distinct (%) | 23.9% |
| Missing | 189575 |
| Missing (%) | 85.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 820.65886 |
| Minimum | 0.1 |
|---|---|
| Maximum | 48910.7 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 0.1 |
|---|---|
| 5-th percentile | 5.4 |
| Q1 | 26.4 |
| median | 107.35 |
| Q3 | 495.15 |
| 95-th percentile | 3838.8 |
| Maximum | 48910.7 |
| Range | 48910.6 |
| Interquartile range (IQR) | 468.75 |
Descriptive statistics
| Standard deviation | 2619.3363 |
|---|---|
| Coefficient of variation (CV) | 3.191748 |
| Kurtosis | 96.728681 |
| Mean | 820.65886 |
| Median Absolute Deviation (MAD) | 96.45 |
| Skewness | 8.401294 |
| Sum | 25960722 |
| Variance | 6860922.5 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 15.9 | 58 | < 0.1% |
| 6 | 57 | < 0.1% |
| 5.4 | 56 | < 0.1% |
| 7.7 | 55 | < 0.1% |
| 20.8 | 54 | < 0.1% |
| 14.9 | 53 | < 0.1% |
| 9 | 52 | < 0.1% |
| 20.7 | 51 | < 0.1% |
| 8.5 | 51 | < 0.1% |
| 12 | 50 | < 0.1% |
| Other values (7563) | 31097 | 14.1% |
| (Missing) | 189575 |
| Value | Count | Frequency (%) |
| 0.1 | 3 | < 0.1% |
| 0.2 | 9 | < 0.1% |
| 0.3 | 9 | < 0.1% |
| 0.4 | 29 | |
| 0.5 | 20 | |
| 0.6 | 20 | |
| 0.7 | 25 | |
| 0.8 | 20 | |
| 0.9 | 39 | |
| 1 | 29 |
| Value | Count | Frequency (%) |
| 48910.7 | 5 | |
| 45292.5 | 2 | < 0.1% |
| 41995.2 | 5 | |
| 40420.4 | 4 | |
| 39388.5 | 2 | < 0.1% |
| 38344.9 | 1 | < 0.1% |
| 38079.6 | 5 | |
| 36270 | 2 | < 0.1% |
| 35800.5 | 2 | < 0.1% |
| 35356.5 | 2 | < 0.1% |
Base_Value
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 67766 |
|---|---|
| Distinct (%) | 51.1% |
| Missing | 88602 |
| Missing (%) | 40.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3632.964 |
| Minimum | 0.080321285 |
|---|---|
| Maximum | 32741.719 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 0.080321285 |
|---|---|
| 5-th percentile | 102.2 |
| Q1 | 1073.1209 |
| median | 2477.3091 |
| Q3 | 5233.4023 |
| 95-th percentile | 10712.4 |
| Maximum | 32741.719 |
| Range | 32741.639 |
| Interquartile range (IQR) | 4160.2813 |
Descriptive statistics
| Standard deviation | 3569.5411 |
|---|---|
| Coefficient of variation (CV) | 0.98254239 |
| Kurtosis | 4.0723146 |
| Mean | 3632.964 |
| Median Absolute Deviation (MAD) | 1728.7906 |
| Skewness | 1.7633723 |
| Sum | 4.8175645 × 108 |
| Variance | 12741624 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2.3 | 155 | 0.1% |
| 2.205882353 | 94 | < 0.1% |
| 0.6 | 74 | < 0.1% |
| 2.1 | 71 | < 0.1% |
| 3.8 | 67 | < 0.1% |
| 5.8 | 66 | < 0.1% |
| 1.9 | 63 | < 0.1% |
| 2.9 | 62 | < 0.1% |
| 0.8 | 62 | < 0.1% |
| 4.8 | 61 | < 0.1% |
| Other values (67756) | 131832 | |
| (Missing) | 88602 |
| Value | Count | Frequency (%) |
| 0.08032128514 | 3 | |
| 0.08130081301 | 1 | < 0.1% |
| 0.08230452675 | 1 | < 0.1% |
| 0.08333333333 | 1 | < 0.1% |
| 0.125 | 1 | < 0.1% |
| 0.1666666667 | 7 | |
| 0.1875 | 2 | < 0.1% |
| 0.1975308642 | 1 | < 0.1% |
| 0.2 | 3 | |
| 0.2409638554 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 32741.71937 | 1 | < 0.1% |
| 28871.62388 | 1 | < 0.1% |
| 28419.17403 | 5 | |
| 28117.2 | 1 | < 0.1% |
| 28020.15191 | 1 | < 0.1% |
| 27620.17444 | 1 | < 0.1% |
| 27365.5 | 3 | |
| 27287.71558 | 1 | < 0.1% |
| 27168.22735 | 3 | |
| 27106.48226 | 1 | < 0.1% |
Non_Promo_Value
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 56646 |
|---|---|
| Distinct (%) | 44.6% |
| Missing | 94079 |
| Missing (%) | 42.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 3717.3165 |
| Minimum | 0.19753086 |
|---|---|
| Maximum | 29015.818 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 0.19753086 |
|---|---|
| 5-th percentile | 59.174748 |
| Q1 | 1031.6 |
| median | 2558.0704 |
| Q3 | 5403.6 |
| 95-th percentile | 11105.383 |
| Maximum | 29015.818 |
| Range | 29015.62 |
| Interquartile range (IQR) | 4372 |
Descriptive statistics
| Standard deviation | 3657.3065 |
|---|---|
| Coefficient of variation (CV) | 0.98385663 |
| Kurtosis | 3.4047599 |
| Mean | 3717.3165 |
| Median Absolute Deviation (MAD) | 1846.0704 |
| Skewness | 1.653216 |
| Sum | 4.7258245 × 108 |
| Variance | 13375891 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 2.3 | 173 | 0.1% |
| 2.205882353 | 98 | < 0.1% |
| 2.9 | 80 | < 0.1% |
| 3.8 | 80 | < 0.1% |
| 1.9 | 75 | < 0.1% |
| 2.1 | 73 | < 0.1% |
| 5.8 | 71 | < 0.1% |
| 0.6 | 68 | < 0.1% |
| 0.5882352941 | 63 | < 0.1% |
| 0.8 | 62 | < 0.1% |
| Other values (56636) | 126287 | |
| (Missing) | 94079 |
| Value | Count | Frequency (%) |
| 0.1975308642 | 1 | < 0.1% |
| 0.2 | 2 | < 0.1% |
| 0.2891566265 | 2 | < 0.1% |
| 0.2926829268 | 2 | < 0.1% |
| 0.3 | 6 | < 0.1% |
| 0.3529411765 | 5 | < 0.1% |
| 0.3855421687 | 41 | |
| 0.3902439024 | 5 | < 0.1% |
| 0.3950617284 | 8 | < 0.1% |
| 0.4 | 8 | < 0.1% |
| Value | Count | Frequency (%) |
| 29015.81781 | 1 | |
| 28850.57471 | 1 | |
| 28345.21264 | 1 | |
| 28182.5 | 1 | |
| 28175.6204 | 1 | |
| 27908.8 | 1 | |
| 27744.91523 | 1 | |
| 27563.32103 | 1 | |
| 27273.71063 | 1 | |
| 27145.5748 | 1 |
Promo_Value
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 17199 |
|---|---|
| Distinct (%) | 54.4% |
| Missing | 189575 |
| Missing (%) | 85.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 2507.6785 |
| Minimum | 0.4 |
|---|---|
| Maximum | 126688.3 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 0.4 |
|---|---|
| 5-th percentile | 25.810091 |
| Q1 | 113.50466 |
| median | 399.37167 |
| Q3 | 1735.8449 |
| 95-th percentile | 11886.4 |
| Maximum | 126688.3 |
| Range | 126687.9 |
| Interquartile range (IQR) | 1622.3402 |
Descriptive statistics
| Standard deviation | 6869.2414 |
|---|---|
| Coefficient of variation (CV) | 2.7392831 |
| Kurtosis | 65.729748 |
| Mean | 2507.6785 |
| Median Absolute Deviation (MAD) | 351.24759 |
| Skewness | 6.8000659 |
| Sum | 79327902 |
| Variance | 47186478 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 20 | 19 | < 0.1% |
| 165.3 | 15 | < 0.1% |
| 68.1 | 11 | < 0.1% |
| 39.5 | 10 | < 0.1% |
| 51.3 | 10 | < 0.1% |
| 31.26838235 | 10 | < 0.1% |
| 21.4 | 9 | < 0.1% |
| 24.8 | 9 | < 0.1% |
| 74.7 | 9 | < 0.1% |
| 57.5 | 9 | < 0.1% |
| Other values (17189) | 31523 | 14.3% |
| (Missing) | 189575 |
| Value | Count | Frequency (%) |
| 0.4 | 1 | |
| 0.8 | 2 | |
| 0.8035714286 | 2 | |
| 0.8333333333 | 1 | |
| 1 | 2 | |
| 1.052631579 | 1 | |
| 1.447963801 | 2 | |
| 1.5 | 1 | |
| 1.666666667 | 1 | |
| 1.718181818 | 1 |
| Value | Count | Frequency (%) |
| 126688.3 | 2 | < 0.1% |
| 111119.6159 | 1 | < 0.1% |
| 110280.4 | 2 | < 0.1% |
| 101901.4417 | 5 | |
| 101395 | 2 | < 0.1% |
| 100944.4806 | 1 | < 0.1% |
| 99105.4 | 2 | < 0.1% |
| 96990.6 | 2 | < 0.1% |
| 92158.7 | 2 | < 0.1% |
| 87779.37996 | 1 | < 0.1% |
Base_Price_Per_KG
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 68257 |
|---|---|
| Distinct (%) | 51.5% |
| Missing | 88602 |
| Missing (%) | 40.1% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.4256412 |
| Minimum | 0.35714286 |
|---|---|
| Maximum | 42.424242 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 0.35714286 |
|---|---|
| 5-th percentile | 1.4452479 |
| Q1 | 2.949965 |
| median | 5.1258199 |
| Q3 | 6.4647452 |
| 95-th percentile | 10.246195 |
| Maximum | 42.424242 |
| Range | 42.0671 |
| Interquartile range (IQR) | 3.5147802 |
Descriptive statistics
| Standard deviation | 3.9050838 |
|---|---|
| Coefficient of variation (CV) | 0.71974604 |
| Kurtosis | 10.314719 |
| Mean | 5.4256412 |
| Median Absolute Deviation (MAD) | 2.0089078 |
| Skewness | 2.754814 |
| Sum | 719478.01 |
| Variance | 15.24968 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 7.352941176 | 134 | 0.1% |
| 1.5 | 128 | 0.1% |
| 1.15 | 119 | 0.1% |
| 5.882352941 | 110 | < 0.1% |
| 2.5 | 104 | < 0.1% |
| 2.1 | 98 | < 0.1% |
| 2 | 97 | < 0.1% |
| 1.75 | 89 | < 0.1% |
| 1.666666667 | 74 | < 0.1% |
| 4.25 | 70 | < 0.1% |
| Other values (68247) | 131584 | |
| (Missing) | 88602 |
| Value | Count | Frequency (%) |
| 0.3571428571 | 1 | < 0.1% |
| 0.4166666667 | 9 | |
| 0.4938271605 | 1 | < 0.1% |
| 0.5 | 5 | |
| 0.6172839506 | 1 | < 0.1% |
| 0.6666666667 | 8 | |
| 0.7228915663 | 2 | < 0.1% |
| 0.7272727273 | 1 | < 0.1% |
| 0.7317073171 | 2 | < 0.1% |
| 0.7429696497 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 42.42424242 | 1 | |
| 38.22916667 | 1 | |
| 34.42906574 | 1 | |
| 33.19496658 | 1 | |
| 31.43959792 | 1 | |
| 31.36130035 | 1 | |
| 31.14641359 | 1 | |
| 31.02651048 | 1 | |
| 30.85420041 | 1 | |
| 30.75933806 | 1 |
Non_Promo_Price_Per_KG
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 60148 |
|---|---|
| Distinct (%) | 47.3% |
| Missing | 94079 |
| Missing (%) | 42.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 5.3789893 |
| Minimum | 0.35714286 |
|---|---|
| Maximum | 33.198507 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 0.35714286 |
|---|---|
| 5-th percentile | 1.4450495 |
| Q1 | 2.9166667 |
| median | 5.0684781 |
| Q3 | 6.4390047 |
| 95-th percentile | 10.164262 |
| Maximum | 33.198507 |
| Range | 32.841364 |
| Interquartile range (IQR) | 3.522338 |
Descriptive statistics
| Standard deviation | 3.8633337 |
|---|---|
| Coefficient of variation (CV) | 0.71822669 |
| Kurtosis | 10.259256 |
| Mean | 5.3789893 |
| Median Absolute Deviation (MAD) | 1.9941571 |
| Skewness | 2.7380305 |
| Sum | 683830.91 |
| Variance | 14.925347 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 3.708333333 | 867 | 0.4% |
| 7.647058824 | 330 | 0.1% |
| 5.294117647 | 162 | 0.1% |
| 0.987654321 | 152 | 0.1% |
| 5.925 | 151 | 0.1% |
| 1.125 | 148 | 0.1% |
| 1.15 | 142 | 0.1% |
| 5.647058824 | 133 | 0.1% |
| 7.352941176 | 133 | 0.1% |
| 1.625 | 133 | 0.1% |
| Other values (60138) | 124779 | |
| (Missing) | 94079 |
| Value | Count | Frequency (%) |
| 0.3571428571 | 1 | < 0.1% |
| 0.4166666667 | 9 | |
| 0.4938271605 | 1 | < 0.1% |
| 0.5 | 6 | |
| 0.6172839506 | 1 | < 0.1% |
| 0.6666666667 | 8 | |
| 0.7228915663 | 3 | < 0.1% |
| 0.7317073171 | 2 | < 0.1% |
| 0.7447885044 | 1 | < 0.1% |
| 0.7475994513 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 33.19850653 | 1 | |
| 31.44008134 | 1 | |
| 31.35667964 | 1 | |
| 31.14838378 | 1 | |
| 31.02471657 | 1 | |
| 30.85296835 | 1 | |
| 30.70731598 | 1 | |
| 30.67713399 | 1 | |
| 30.67146283 | 1 | |
| 30.59818396 | 1 |
Promo_Price_Per_KG
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 17368 |
|---|---|
| Distinct (%) | 54.9% |
| Missing | 189575 |
| Missing (%) | 85.7% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 4.7793283 |
| Minimum | 0.41666667 |
|---|---|
| Maximum | 30.123457 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 0.41666667 |
|---|---|
| 5-th percentile | 1.1444135 |
| Q1 | 2.5817931 |
| median | 3.8623035 |
| Q3 | 5.7158644 |
| 95-th percentile | 10.665601 |
| Maximum | 30.123457 |
| Range | 29.70679 |
| Interquartile range (IQR) | 3.1340712 |
Descriptive statistics
| Standard deviation | 3.7277254 |
|---|---|
| Coefficient of variation (CV) | 0.77996847 |
| Kurtosis | 9.8329525 |
| Mean | 4.7793283 |
| Median Absolute Deviation (MAD) | 1.5376007 |
| Skewness | 2.8022569 |
| Sum | 151189.27 |
| Variance | 13.895936 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 6.25 | 20 | < 0.1% |
| 2.941176471 | 19 | < 0.1% |
| 2.5 | 16 | < 0.1% |
| 1.470588235 | 15 | < 0.1% |
| 1.666666667 | 11 | < 0.1% |
| 2.066666667 | 11 | < 0.1% |
| 3.055555556 | 11 | < 0.1% |
| 1.25 | 11 | < 0.1% |
| 2.25 | 11 | < 0.1% |
| 3.666666667 | 10 | < 0.1% |
| Other values (17358) | 31499 | 14.2% |
| (Missing) | 189575 |
| Value | Count | Frequency (%) |
| 0.4166666667 | 1 | < 0.1% |
| 0.418760469 | 1 | < 0.1% |
| 0.4212792128 | 1 | < 0.1% |
| 0.422979798 | 5 | |
| 0.4444444444 | 2 | < 0.1% |
| 0.4539219354 | 1 | < 0.1% |
| 0.470917653 | 1 | < 0.1% |
| 0.4892601432 | 1 | < 0.1% |
| 0.5 | 2 | < 0.1% |
| 0.5014326648 | 1 | < 0.1% |
| Value | Count | Frequency (%) |
| 30.12345679 | 2 | |
| 30 | 1 | |
| 29.96937009 | 1 | |
| 29.9482278 | 1 | |
| 29.90106545 | 1 | |
| 29.84126984 | 1 | |
| 29.81715893 | 1 | |
| 29.79423868 | 1 | |
| 29.66432475 | 1 | |
| 29.60885149 | 1 |
Distribution_wtd
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 100 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 91859 |
| Missing (%) | 41.5% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 70.047623 |
| Minimum | 1 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 8 |
| Q1 | 57 |
| median | 80 |
| Q3 | 91 |
| 95-th percentile | 98 |
| Maximum | 100 |
| Range | 99 |
| Interquartile range (IQR) | 34 |
Descriptive statistics
| Standard deviation | 27.213001 |
|---|---|
| Coefficient of variation (CV) | 0.38849285 |
| Kurtosis | 0.20055124 |
| Mean | 70.047623 |
| Median Absolute Deviation (MAD) | 14 |
| Skewness | -1.1166167 |
| Sum | 9060660 |
| Variance | 740.54741 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 91 | 4173 | 1.9% |
| 92 | 4075 | 1.8% |
| 90 | 4013 | 1.8% |
| 93 | 3861 | 1.7% |
| 89 | 3845 | 1.7% |
| 94 | 3785 | 1.7% |
| 95 | 3433 | 1.6% |
| 88 | 3339 | 1.5% |
| 97 | 3324 | 1.5% |
| 96 | 3278 | 1.5% |
| Other values (90) | 92224 | |
| (Missing) | 91859 |
| Value | Count | Frequency (%) |
| 1 | 1865 | |
| 2 | 711 | 0.3% |
| 3 | 516 | 0.2% |
| 4 | 620 | 0.3% |
| 5 | 907 | |
| 6 | 1251 | |
| 7 | 495 | 0.2% |
| 8 | 350 | 0.2% |
| 9 | 509 | 0.2% |
| 10 | 630 | 0.3% |
| Value | Count | Frequency (%) |
| 100 | 2095 | |
| 99 | 2890 | |
| 98 | 3082 | |
| 97 | 3324 | |
| 96 | 3278 | |
| 95 | 3433 | |
| 94 | 3785 | |
| 93 | 3861 | |
| 92 | 4075 | |
| 91 | 4173 |
Distribution_numeric
Real number (ℝ)
HIGH CORRELATION MISSING
| Distinct | 100 |
|---|---|
| Distinct (%) | 0.1% |
| Missing | 91613 |
| Missing (%) | 41.4% |
| Infinite | 0 |
| Infinite (%) | 0.0% |
| Mean | 61.148816 |
| Minimum | 1 |
|---|---|
| Maximum | 100 |
| Zeros | 0 |
| Zeros (%) | 0.0% |
| Negative | 0 |
| Negative (%) | 0.0% |
| Memory size | 1.7 MiB |
Quantile statistics
| Minimum | 1 |
|---|---|
| 5-th percentile | 4 |
| Q1 | 45 |
| median | 68 |
| Q3 | 84 |
| 95-th percentile | 95 |
| Maximum | 100 |
| Range | 99 |
| Interquartile range (IQR) | 39 |
Descriptive statistics
| Standard deviation | 27.682803 |
|---|---|
| Coefficient of variation (CV) | 0.452712 |
| Kurtosis | -0.51557583 |
| Mean | 61.148816 |
| Median Absolute Deviation (MAD) | 18 |
| Skewness | -0.73570699 |
| Sum | 7924642 |
| Variance | 766.33757 |
| Monotonicity | Not monotonic |
Histogram with fixed size bins (bins=50)
| Value | Count | Frequency (%) |
| 89 | 2974 | 1.3% |
| 88 | 2858 | 1.3% |
| 2 | 2850 | 1.3% |
| 85 | 2679 | 1.2% |
| 87 | 2621 | 1.2% |
| 84 | 2591 | 1.2% |
| 83 | 2499 | 1.1% |
| 86 | 2435 | 1.1% |
| 75 | 2368 | 1.1% |
| 76 | 2361 | 1.1% |
| Other values (90) | 103360 | |
| (Missing) | 91613 |
| Value | Count | Frequency (%) |
| 1 | 2299 | |
| 2 | 2850 | |
| 3 | 952 | 0.4% |
| 4 | 1199 | |
| 5 | 558 | 0.3% |
| 6 | 510 | 0.2% |
| 7 | 417 | 0.2% |
| 8 | 461 | 0.2% |
| 9 | 555 | 0.3% |
| 10 | 770 | 0.3% |
| Value | Count | Frequency (%) |
| 100 | 331 | 0.1% |
| 99 | 1087 | |
| 98 | 2080 | |
| 97 | 1142 | |
| 96 | 1219 | |
| 95 | 1199 | |
| 94 | 1562 | |
| 93 | 2353 | |
| 92 | 1806 | |
| 91 | 1811 |
| Week_Num | Pack_Size_Num | Category_Value | Category_Volume | Base_Volume | Non_Promo_Volume | Promo_Volume | Base_Value | Non_Promo_Value | Promo_Value | Base_Price_Per_KG | Non_Promo_Price_Per_KG | Promo_Price_Per_KG | Distribution_wtd | Distribution_numeric | Retailer_Name | Category | Brand | Sub_Brand | Pack_Type | Pack_Size | Modelling_Group | F_Group | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Week_Num | 1.000 | 0.010 | 0.034 | -0.033 | -0.035 | -0.038 | -0.028 | -0.011 | -0.014 | -0.014 | 0.036 | 0.040 | 0.030 | -0.021 | -0.024 | 0.007 | 0.056 | 0.033 | 0.036 | 0.041 | 0.042 | 0.042 | 0.045 |
| Pack_Size_Num | 0.010 | 1.000 | -0.187 | -0.159 | 0.310 | 0.302 | 0.270 | 0.064 | 0.066 | 0.074 | -0.655 | -0.649 | -0.711 | -0.191 | -0.179 | 0.151 | 0.617 | 0.572 | 0.662 | 0.520 | 1.000 | 0.729 | 1.000 |
| Category_Value | 0.034 | -0.187 | 1.000 | 0.985 | 0.275 | 0.260 | -0.038 | 0.403 | 0.382 | -0.033 | 0.182 | 0.184 | 0.042 | -0.193 | -0.292 | 0.853 | 0.641 | 0.203 | 0.204 | 0.322 | 0.243 | 0.231 | 0.245 |
| Category_Volume | -0.033 | -0.159 | 0.985 | 1.000 | 0.297 | 0.281 | 0.002 | 0.416 | 0.394 | -0.003 | 0.152 | 0.154 | -0.000 | -0.188 | -0.293 | 0.797 | 0.508 | 0.171 | 0.156 | 0.256 | 0.188 | 0.174 | 0.190 |
| Base_Volume | -0.035 | 0.310 | 0.275 | 0.297 | 1.000 | 0.969 | 0.267 | 0.881 | 0.847 | 0.111 | -0.436 | -0.437 | -0.509 | 0.475 | 0.411 | 0.164 | 0.142 | 0.200 | 0.259 | 0.186 | 0.240 | 0.176 | 0.297 |
| Non_Promo_Volume | -0.038 | 0.302 | 0.260 | 0.281 | 0.969 | 1.000 | 0.170 | 0.854 | 0.886 | -0.005 | -0.420 | -0.418 | -0.499 | 0.476 | 0.413 | 0.186 | 0.147 | 0.201 | 0.258 | 0.189 | 0.239 | 0.178 | 0.302 |
| Promo_Volume | -0.028 | 0.270 | -0.038 | 0.002 | 0.267 | 0.170 | 1.000 | 0.168 | 0.004 | 0.949 | -0.294 | -0.431 | -0.360 | 0.389 | 0.340 | 0.101 | 0.029 | 0.038 | 0.059 | 0.033 | 0.057 | 0.036 | 0.075 |
| Base_Value | -0.011 | 0.064 | 0.403 | 0.416 | 0.881 | 0.854 | 0.168 | 1.000 | 0.963 | 0.133 | -0.028 | -0.026 | -0.127 | 0.468 | 0.383 | 0.391 | 0.108 | 0.116 | 0.226 | 0.167 | 0.162 | 0.137 | 0.240 |
| Non_Promo_Value | -0.014 | 0.066 | 0.382 | 0.394 | 0.847 | 0.886 | 0.004 | 0.963 | 1.000 | -0.045 | -0.022 | -0.020 | -0.150 | 0.462 | 0.381 | 0.428 | 0.109 | 0.120 | 0.234 | 0.169 | 0.161 | 0.138 | 0.246 |
| Promo_Value | -0.014 | 0.074 | -0.033 | -0.003 | 0.111 | -0.005 | 0.949 | 0.133 | -0.045 | 1.000 | -0.023 | -0.123 | -0.075 | 0.391 | 0.344 | 0.120 | 0.038 | 0.049 | 0.071 | 0.034 | 0.067 | 0.040 | 0.086 |
| Base_Price_Per_KG | 0.036 | -0.655 | 0.182 | 0.152 | -0.436 | -0.420 | -0.294 | -0.028 | -0.022 | -0.023 | 1.000 | 0.999 | 0.930 | -0.110 | -0.113 | 0.087 | 0.558 | 0.397 | 0.673 | 0.467 | 0.648 | 0.438 | 0.690 |
| Non_Promo_Price_Per_KG | 0.040 | -0.649 | 0.184 | 0.154 | -0.437 | -0.418 | -0.431 | -0.026 | -0.020 | -0.123 | 0.999 | 1.000 | 0.941 | -0.117 | -0.117 | 0.110 | 0.667 | 0.370 | 0.712 | 0.452 | 0.682 | 0.522 | 0.748 |
| Promo_Price_Per_KG | 0.030 | -0.711 | 0.042 | -0.000 | -0.509 | -0.499 | -0.360 | -0.127 | -0.150 | -0.075 | 0.930 | 0.941 | 1.000 | -0.064 | -0.047 | 0.130 | 0.574 | 0.328 | 0.564 | 0.381 | 0.566 | 0.457 | 0.599 |
| Distribution_wtd | -0.021 | -0.191 | -0.193 | -0.188 | 0.475 | 0.476 | 0.389 | 0.468 | 0.462 | 0.391 | -0.110 | -0.117 | -0.064 | 1.000 | 0.978 | 0.241 | 0.126 | 0.169 | 0.291 | 0.227 | 0.236 | 0.178 | 0.316 |
| Distribution_numeric | -0.024 | -0.179 | -0.292 | -0.293 | 0.411 | 0.413 | 0.340 | 0.383 | 0.381 | 0.344 | -0.113 | -0.117 | -0.047 | 0.978 | 1.000 | 0.320 | 0.143 | 0.180 | 0.289 | 0.228 | 0.242 | 0.182 | 0.315 |
| Retailer_Name | 0.007 | 0.151 | 0.853 | 0.797 | 0.164 | 0.186 | 0.101 | 0.391 | 0.428 | 0.120 | 0.087 | 0.110 | 0.130 | 0.241 | 0.320 | 1.000 | 0.085 | 0.315 | 0.179 | 0.057 | 0.183 | 0.115 | 0.199 |
| Category | 0.056 | 0.617 | 0.641 | 0.508 | 0.142 | 0.147 | 0.029 | 0.108 | 0.109 | 0.038 | 0.558 | 0.667 | 0.574 | 0.126 | 0.143 | 0.085 | 1.000 | 0.499 | 0.868 | 0.697 | 1.000 | 1.000 | 1.000 |
| Brand | 0.033 | 0.572 | 0.203 | 0.171 | 0.200 | 0.201 | 0.038 | 0.116 | 0.120 | 0.049 | 0.397 | 0.370 | 0.328 | 0.169 | 0.180 | 0.315 | 0.499 | 1.000 | 0.881 | 0.567 | 0.577 | 0.477 | 0.944 |
| Sub_Brand | 0.036 | 0.662 | 0.204 | 0.156 | 0.259 | 0.258 | 0.059 | 0.226 | 0.234 | 0.071 | 0.673 | 0.712 | 0.564 | 0.291 | 0.289 | 0.179 | 0.868 | 0.881 | 1.000 | 0.891 | 0.757 | 0.587 | 0.784 |
| Pack_Type | 0.041 | 0.520 | 0.322 | 0.256 | 0.186 | 0.189 | 0.033 | 0.167 | 0.169 | 0.034 | 0.467 | 0.452 | 0.381 | 0.227 | 0.228 | 0.057 | 0.697 | 0.567 | 0.891 | 1.000 | 0.873 | 0.729 | 0.998 |
| Pack_Size | 0.042 | 1.000 | 0.243 | 0.188 | 0.240 | 0.239 | 0.057 | 0.162 | 0.161 | 0.067 | 0.648 | 0.682 | 0.566 | 0.236 | 0.242 | 0.183 | 1.000 | 0.577 | 0.757 | 0.873 | 1.000 | 0.585 | 0.943 |
| Modelling_Group | 0.042 | 0.729 | 0.231 | 0.174 | 0.176 | 0.178 | 0.036 | 0.137 | 0.138 | 0.040 | 0.438 | 0.522 | 0.457 | 0.178 | 0.182 | 0.115 | 1.000 | 0.477 | 0.587 | 0.729 | 0.585 | 1.000 | 0.756 |
| F_Group | 0.045 | 1.000 | 0.245 | 0.190 | 0.297 | 0.302 | 0.075 | 0.240 | 0.246 | 0.086 | 0.690 | 0.748 | 0.599 | 0.316 | 0.315 | 0.199 | 1.000 | 0.944 | 0.784 | 0.998 | 0.943 | 0.756 | 1.000 |
A simple visualization of nullity by column.
Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.
The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.
| PPG | Week | Week_Num | Retailer_Name | Category | Brand | Sub_Brand | Pack_Type | Pack_Size | Pack_Size_Num | Category_Value | Category_Volume | Modelling_Group | F_Group | Base_Volume | Non_Promo_Volume | Promo_Volume | Base_Value | Non_Promo_Value | Promo_Value | Base_Price_Per_KG | Non_Promo_Price_Per_KG | Promo_Price_Per_KG | Distribution_wtd | Distribution_numeric | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | BRAND A SUBBRAND A.1 ADULT ZAK GROENTE_KIP_RIJST 1500_G | wk 18 21 | 9 | Retailer A | DRY | BRAND A | SUBBRAND A.1 | ZAK | 1500_G | 1500 | 323026.4 | 90161.0 | BRAND B DRY NUGGETS REGULAR 3X3KG | BRAND A DRY 1,5KG | 94.3 | NaN | 148.5 | 267.583758 | NaN | 341.9 | 2.837580 | NaN | 2.302357 | 7.0 | 3.0 |
| 1 | BRAND A SUBBRAND A.1 ADULT ZAK GROENTE_KIP_RIJST 1500_G | wk 18 21 | 9 | Retailer B | DRY | BRAND A | SUBBRAND A.1 | ZAK | 1500_G | 1500 | 47785.2 | 16947.6 | BRAND B DRY NUGGETS REGULAR 3X3KG | BRAND A DRY 1,5KG | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 2 | BRAND A SUBBRAND A.1 ADULT ZAK GROENTE_KIP_RIJST 1500_G | wk 18 21 | 9 | Retailer C | DRY | BRAND A | SUBBRAND A.1 | ZAK | 1500_G | 1500 | 232030.1 | 74702.1 | BRAND B DRY NUGGETS REGULAR 3X3KG | BRAND A DRY 1,5KG | 184.2 | 264.0 | NaN | 501.400000 | 719.9 | NaN | 2.722041 | 2.726894 | NaN | 24.0 | 16.0 |
| 3 | BRAND A SUBBRAND A.1 ADULT ZAK GROENTE_KIP_RIJST 1500_G | wk 18 22 | 10 | Retailer A | DRY | BRAND A | SUBBRAND A.1 | ZAK | 1500_G | 1500 | 315345.8 | 88364.6 | BRAND B DRY NUGGETS REGULAR 3X3KG | BRAND A DRY 1,5KG | 55.5 | 87.0 | NaN | 158.900000 | 248.8 | NaN | 2.863063 | 2.859770 | NaN | 6.0 | 3.0 |
| 4 | BRAND A SUBBRAND A.1 ADULT ZAK GROENTE_KIP_RIJST 1500_G | wk 18 22 | 10 | Retailer B | DRY | BRAND A | SUBBRAND A.1 | ZAK | 1500_G | 1500 | 103000.8 | 33226.4 | BRAND B DRY NUGGETS REGULAR 3X3KG | BRAND A DRY 1,5KG | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 5 | BRAND A SUBBRAND A.1 ADULT ZAK GROENTE_KIP_RIJST 1500_G | wk 18 22 | 10 | Retailer C | DRY | BRAND A | SUBBRAND A.1 | ZAK | 1500_G | 1500 | 217268.0 | 69354.0 | BRAND B DRY NUGGETS REGULAR 3X3KG | BRAND A DRY 1,5KG | 157.9 | 253.5 | NaN | 436.261855 | 701.3 | NaN | 2.762900 | 2.766469 | NaN | 23.0 | 16.0 |
| 6 | BRAND A SUBBRAND A.1 ADULT ZAK GROENTE_KIP_RIJST 1500_G | wk 18 23 | 11 | Retailer A | DRY | BRAND A | SUBBRAND A.1 | ZAK | 1500_G | 1500 | 307502.0 | 85380.4 | BRAND B DRY NUGGETS REGULAR 3X3KG | BRAND A DRY 1,5KG | 48.2 | 93.0 | NaN | 137.943095 | 266.0 | NaN | 2.861890 | 2.860215 | NaN | 6.0 | 3.0 |
| 7 | BRAND A SUBBRAND A.1 ADULT ZAK GROENTE_KIP_RIJST 1500_G | wk 18 23 | 11 | Retailer B | DRY | BRAND A | SUBBRAND A.1 | ZAK | 1500_G | 1500 | 78540.4 | 32781.1 | BRAND B DRY NUGGETS REGULAR 3X3KG | BRAND A DRY 1,5KG | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 8 | BRAND A SUBBRAND A.1 ADULT ZAK GROENTE_KIP_RIJST 1500_G | wk 18 23 | 11 | Retailer C | DRY | BRAND A | SUBBRAND A.1 | ZAK | 1500_G | 1500 | 218625.2 | 69515.0 | BRAND B DRY NUGGETS REGULAR 3X3KG | BRAND A DRY 1,5KG | 321.3 | 262.5 | NaN | 882.200000 | 722.3 | NaN | 2.745721 | 2.751619 | NaN | 21.0 | 15.0 |
| 9 | BRAND A SUBBRAND A.1 ADULT ZAK GROENTE_KIP_RIJST 1500_G | wk 18 24 | 12 | Retailer A | DRY | BRAND A | SUBBRAND A.1 | ZAK | 1500_G | 1500 | 338839.8 | 97684.8 | BRAND B DRY NUGGETS REGULAR 3X3KG | BRAND A DRY 1,5KG | 87.3 | 85.5 | NaN | 249.600000 | 244.5 | NaN | 2.859107 | 2.859649 | NaN | 7.0 | 3.0 |
| PPG | Week | Week_Num | Retailer_Name | Category | Brand | Sub_Brand | Pack_Type | Pack_Size | Pack_Size_Num | Category_Value | Category_Volume | Modelling_Group | F_Group | Base_Volume | Non_Promo_Volume | Promo_Volume | Base_Value | Non_Promo_Value | Promo_Value | Base_Price_Per_KG | Non_Promo_Price_Per_KG | Promo_Price_Per_KG | Distribution_wtd | Distribution_numeric | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 221199 | BRAND O SUBBRAND O.6 ADULT BAK ZEEVRUCHTEN 60_G | wk 21 37 | 182 | Retailer C | SNACKS | BRAND O | SUBBRAND O.6 | BAK | 60_G | 60 | NaN | NaN | BRAND D SNACKS PARTY MIX 60G | BRAND O SNACKS 60G | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 221200 | BRAND O SUBBRAND O.6 ADULT BAK ZEEVRUCHTEN 60_G | wk 21 38 | 183 | Retailer A | SNACKS | BRAND O | SUBBRAND O.6 | BAK | 60_G | 60 | NaN | NaN | BRAND D SNACKS PARTY MIX 60G | BRAND O SNACKS 60G | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 221201 | BRAND O SUBBRAND O.6 ADULT BAK ZEEVRUCHTEN 60_G | wk 21 38 | 183 | Retailer B | SNACKS | BRAND O | SUBBRAND O.6 | BAK | 60_G | 60 | NaN | NaN | BRAND D SNACKS PARTY MIX 60G | BRAND O SNACKS 60G | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 221202 | BRAND O SUBBRAND O.6 ADULT BAK ZEEVRUCHTEN 60_G | wk 21 38 | 183 | Retailer C | SNACKS | BRAND O | SUBBRAND O.6 | BAK | 60_G | 60 | NaN | NaN | BRAND D SNACKS PARTY MIX 60G | BRAND O SNACKS 60G | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 221203 | BRAND O SUBBRAND O.6 ADULT BAK ZEEVRUCHTEN 60_G | wk 21 39 | 184 | Retailer A | SNACKS | BRAND O | SUBBRAND O.6 | BAK | 60_G | 60 | NaN | NaN | BRAND D SNACKS PARTY MIX 60G | BRAND O SNACKS 60G | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 221204 | BRAND O SUBBRAND O.6 ADULT BAK ZEEVRUCHTEN 60_G | wk 21 39 | 184 | Retailer B | SNACKS | BRAND O | SUBBRAND O.6 | BAK | 60_G | 60 | NaN | NaN | BRAND D SNACKS PARTY MIX 60G | BRAND O SNACKS 60G | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 221205 | BRAND O SUBBRAND O.6 ADULT BAK ZEEVRUCHTEN 60_G | wk 21 39 | 184 | Retailer C | SNACKS | BRAND O | SUBBRAND O.6 | BAK | 60_G | 60 | NaN | NaN | BRAND D SNACKS PARTY MIX 60G | BRAND O SNACKS 60G | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 221206 | BRAND O SUBBRAND O.6 ADULT BAK ZEEVRUCHTEN 60_G | wk 21 40 | 185 | Retailer A | SNACKS | BRAND O | SUBBRAND O.6 | BAK | 60_G | 60 | NaN | NaN | BRAND D SNACKS PARTY MIX 60G | BRAND O SNACKS 60G | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 221207 | BRAND O SUBBRAND O.6 ADULT BAK ZEEVRUCHTEN 60_G | wk 21 40 | 185 | Retailer B | SNACKS | BRAND O | SUBBRAND O.6 | BAK | 60_G | 60 | NaN | NaN | BRAND D SNACKS PARTY MIX 60G | BRAND O SNACKS 60G | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |
| 221208 | BRAND O SUBBRAND O.6 ADULT BAK ZEEVRUCHTEN 60_G | wk 21 40 | 185 | Retailer C | SNACKS | BRAND O | SUBBRAND O.6 | BAK | 60_G | 60 | NaN | NaN | BRAND D SNACKS PARTY MIX 60G | BRAND O SNACKS 60G | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN | NaN |